Skip Headers

Oracle® Database Advanced Replication Management API Reference 10g Release 2 (10.2) Part Number B14227-01 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G I J L M N O P Q R S T U V W

## A

  ADD procedure, 5.2.2, 8.5, 17
  ADD_DEFAULT_DEST procedure, 14
  ADD_DELETE_RESOLUTION procedure, 18
  ADD_GROUPED_COLUMN procedure, 18
  ADD_MASTER_DATABASE procedure, 3.2, 7.2.2, 7.2.2.1, 18
  ADD_NEW_MASTERS procedure, 7.2.1.1, 7.2.1.2, 18
  ADD_PRIORITY_CHAR procedure, 18
  ADD_PRIORITY_datatype procedure, 18
  ADD_PRIORITY_DATE procedure, 18
  ADD_PRIORITY_NUMBER procedure, 18
  ADD_PRIORITY_VARCHAR2 procedure, 18
  ADD_SITE_PRIORITY_SITE procedure, 6.2.6, 18
  ADD_UNIQUENESS_RESOLUTION procedure, 18
  ADD_UPDATE_RESOLUTION procedure, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6, 18
  administrative requests
    ALL_REPCATLOG view, 23
    executing, 7.2.2.2, 18
    monitoring, 10.3
      errors, 10.3.2
      jobs, 10.3.3
    purging, 18
  administrators
    for materialized view sites
      creating, 2.3.1
  Advanced Replication
    migrating to Streams, 18
  ALL_REPCAT_REFRESH_TEMPLATES view, 23
  ALL_REPCAT_TEMPLATE_OBJECTS view, 23
  ALL_REPCAT_TEMPLATE_PARMS view, 23
  ALL_REPCAT_TEMPLATE_SITES view, 23
  ALL_REPCAT_USER_AUTHORIZATIONS view, 23
  ALL_REPCAT_USER_PARM_VALUES view, 23
  ALL_REPCATLOG view
    administrative requests, 23
  ALL_REPCOLUMN view, 23
  ALL_REPCOLUMN_GROUP view, 23
  ALL_REPCONFLICT view, 23
  ALL_REPDDL view, 23
  ALL_REPGENOBJECTS view, 23
  ALL_REPGROUP view, 23
  ALL_REPGROUP_PRIVILEGES view, 23
  ALL_REPGROUPED_COLUMN view, 23
  ALL_REPKEY_COLUMNS view, 23
  ALL_REPOBJECT view, 23
  ALL_REPPARAMETER_COLUMN view, 23
  ALL_REPPRIORITY view, 23
  ALL_REPPRIORITY_GROUP view, 23
  ALL_REPPROP view, 23
  ALL_REPRESOL_STATS_CONTROL view, 23
  ALL_REPRESOLUTION view, 23
  ALL_REPRESOLUTION_METHOD view, 23
  ALL_REPRESOLUTION_STATISTICS view, 23
    gathering statistics, 6.6
  ALL_REPSITES view, 23
  ALTER MATERIALIZED VIEW LOG statement, 8.4.1.1, 8.4.1.2
  ALTER_CATCHUP_PARAMETERS procedure, 18
  ALTER_MASTER_PROPAGATION procedure, 18
  ALTER_MASTER_REPOBJECT procedure, 6.2.3, 6.2.6, 6.4, 9.1.1, 18
  ALTER_MVIEW_PROPAGATION procedure, 18
  ALTER_PRIORITY procedure, 18
  ALTER_PRIORITY_CHAR procedure, 18
  ALTER_PRIORITY_datatype procedure, 18
  ALTER_PRIORITY_DATE procedure, 18
  ALTER_PRIORITY_NUMBER procedure, 18
  ALTER_PRIORITY_RAW procedure, 18
  ALTER_REFRESH_TEMPLATE procedure, 21
  ALTER_SITE_PRIORITY procedure, 18
  ALTER_SITE_PRIORITY_SITE procedure, 18
  ALTER_TEMPLATE_OBJECT procedure, 21
  ALTER_TEMPLATE_PARM procedure, 21
  ALTER_USER_AUTHORIZATION procedure, 21
  ALTER_USER_PARM_VALUE procedure, 21
  ANY_CHAR_ARG procedure, 12
  ANY_CLOB_ARG procedure, 12
  ANY_VARCHAR2_ARG procedure, 12
  ANYDATA
    GET_ANYDATA_ARG function, 13
  ANYDATA datatype
    replication, 9.5.3
  ANYDATA_ARG procedure, 12
  authorization
    template users, 4.3
  availability
    extended, 6.2, 7.2.1, 9.1.1, 18, 18, 18, 18, 18, 18

## B

  BEGIN_INSTANTIATION procedure, 7.2.2.2, 15
  BEGIN_LOAD procedure, 7.2.2.2, 15
  BEGIN_TABLE_REORGANIZATION, 8.4.3.1
  BLOB_ARG procedure, 12

## C

  CALL procedure, 12
  CANCEL_STATISTICS procedure, 6.6.3, 18
  CHANGE procedure, 17
  CHAR_ARG procedure, 12
  CLEAR_PROP_STATISTICS procedure, 10.6.6, 14
  CLOB_ARG procedure, 12
  column objects
    user-defined conflict resolution, B.1.1
  column subsetting
    user-defined conflict resolution methods, B.1.6.2
  columns
    adding to master tables, 18
    column groups, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6
      adding members to, 18
      creating, 18, 18
      dropping, 18
      removing members from, 18
  COMMENT_ON_COLUMN_GROUP procedure, 18
  COMMENT_ON_DELETE_RESOLUTION procedure, 18
  COMMENT_ON_MVIEW_REPSITES procedure, 18
  COMMENT_ON_PRIORITY procedure, 18
  COMMENT_ON_REPGROUP procedure, 18
  COMMENT_ON_REPOBJECT procedure, 18
  COMMENT_ON_REPSITES procedure, 18
  COMMENT_ON_SITE_PRIORITY procedure, 18
  COMMENT_ON_UNIQUE_RESOLUTION procedure, 18
  COMMENT_ON_UPDATE_RESOLUTION procedure, 18
  comments
    comments field
      updating in views, 7.4
    updating, 7.4
  COMMIT_WORK procedure, 12
  COMPARE_OLD_VALUES procedure, 18, 18
  COMPARE_TEMPLATES function, 21
  comparing
    tables, 16
  conflict resolution, 6
    additive method, 6.2.4, 18
    auditing, 6.6, 6.6
    average method, 6.2.4
    column groups, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6
    configuring without quiesce, 6.2
    DBA_REPRESOLUTION_STATISTICS view, 6.6.4
    discard method, 6.2.1
    information
      viewing, B.3
    maximum method, 6.2.2
    minimum method, 6.2.2
    overwrite method, 6.2.1
    preparing for, 6.1
    priority groups method, 6.2.5
    procedural replication and, 7.5.3
    site priority method, 6.2.6
      sample trigger, 6.2.6
    statistics, 18, 18
      canceling, 6.6.3
      collecting, 6.6.1
      viewing, 6.6.2
    timestamp method, 6.2.3
      sample trigger, 6.2.3
    uniqueness, 6.3
    user-defined methods, B.1
      column objects, B.1.1
      column subsetting, B.1.6.2
      example, B.1.7
      for delete conflicts, B.1.4
      for uniqueness conflicts, B.1.3
      for update conflicts, B.1.2
      multitier materialized views, B.1.5
      parameters, B.1.1
      restrictions, B.1.6
    viewing information, B.3
  conflicts
    avoiding
      delete, 6.4
      dynamic ownership, 6.5
    notification log table
      creating, B.2.1
      sample, B.2.1.1
    notification methods
      user-defined, B.2
    notification package
      creating, B.2.2
      sample, B.2.2.1
    token passing, 6.5.2
    workflow, 6.5.1
  COPY_TEMPLATE function, 21
  CREATE_MASTER_REPGROUP procedure, 3.2, 18
  CREATE_MASTER_REPOBJECT procedure, 6.2.3, 6.2.6, 18
  CREATE_MVIEW_REPGROUP procedure, 5.2.1, 8.5, 8.6, 8.6, 18
  CREATE_MVIEW_REPOBJECT procedure, 5.2.1, 5.2.1, 5.2.2, 5.2.2, 8.6, 8.6, 18
  CREATE_OBJECT_FROM_EXISTING function, 21
  CREATE_REFRESH_TEMPLATE function, 21
  CREATE_REFRESH_TEMPLATE procedure, 4.3
  CREATE_TEMPLATE_OBJECT function, 21
  CREATE_TEMPLATE_OBJECT procedure, 4.3
  CREATE_TEMPLATE_PARM function, 21
  CREATE_USER_AUTHORIZATION function, 21
  CREATE_USER_AUTHORIZATION procedure, 4.3
  CREATE_USER_PARM_VALUE function, 21

## D

  data definition language
    altering replicated objects, 18
    asynchronous, 18
  data dictionary views
    comments
      updating, 7.4
    materialized views, 26
    refresh groups, 26
    replication, 10, 23
  database links
    creating, 2.2.4, 2.3.2, 4.4.4, 5.2.1, 5.2.2, 8.6
  datatype_ARG procedure, 12
  date expressions, 2.2.1
  DATE_ARG procedure, 12
  DBA_REGISTERED_MVIEW_GROUPS view, 23
  DBA_REPCAT_REFRESH_TEMPLATES view, 23
  DBA_REPCAT_TEMPLATE_OBJECTS view, 23
  DBA_REPCAT_TEMPLATE_PARMS view, 23
  DBA_REPCAT_TEMPLATE_SITES view, 23
  DBA_REPCAT_USER_AUTHORIZATIONS view, 23
  DBA_REPCAT_USER_PARM_VALUES view, 23
  DBA_REPCATLOG view, 23
    purging requests from, 18
  DBA_REPCOLUMN view, 23
  DBA_REPCOLUMN_GROUP view, 23
    updating, 18
  DBA_REPCONFLICT view, 23
  DBA_REPDDL view, 23
  DBA_REPEXTENSIONS view, 23
  DBA_REPGENOBJECTS view, 23
  DBA_REPGROUP view, 23
    updating, 18
  DBA_REPGROUP_PRIVILEGES view, 23
  DBA_REPGROUPED_COLUMN view, 23
  DBA_REPKEY_COLUMNS view, 23
  DBA_REPOBJECT view, 23
    updating, 18
  DBA_REPPARAMETER_COLUMN view, 23
  DBA_REPPRIORITY view, 23
  DBA_REPPRIORITY_GROUP view, 23
  DBA_REPPRIORITYGROUP view
    updating, 18, 18
  DBA_REPPROP view, 23
  DBA_REPRESOL_STATS_CONTROL view, 23
  DBA_REPRESOLUTION view, 23
    updating, 18
  DBA_REPRESOLUTION_METHOD view, 23, 23
  DBA_REPRESOLUTION_STATISTICS view, 23
    purging, 6.6.4, 18
  DBA_REPSITES view, 23
    updating, 18
  DBA_REPSITES_NEW view, 23
  DBMS_DEFER package, 12
  DBMS_DEFER_QUERY package, 13
    GET_ANYDATA_ARG function, 9.5.3
  DBMS_DEFER_SYS package, 14
    CLEAR_PROP_STATISTICS procedure, 10.6.6
    EXECUTE_ERROR procedure, 7.2.2.2, 9.6.1
    EXECUTE_ERROR_AS_USER procedure, 9.6.2
    PURGE function, 9.5.2
    PUSH function, 9.5.1
    REGISTER_PROPAGATOR procedure, 2.2.1, 2.3.1, 2.3.2
    SCHEDULE_PURGE procedure, 2.2.1, 2.3.1, 2.3.2
    SCHEDULE_PUSH procedure, 2.2.4, 2.2.4, 2.3.1, 2.3.2
  DBMS_MVIEW package
    BEGIN_TABLE_REORGANIZATION procedure, 8.4.3.1
    END_TABLE_REORGANIZATION procedure, 8.4.3.1
    PURGE_LOG procedure, 8.4.2.1
    PURGE_MVIEW_FROM_LOG procedure, 8.3.3.1, 8.3.3.2, 8.3.3.2, 8.4.2.1
    REFRESH procedure, 8.1, 8.5
    UNREGISTER_MVIEW procedure, 8.3.3.2
  DBMS_OFFLINE_OG package, 15
    BEGIN_INSTANTIATION procedure, 7.2.2.2
    BEGIN_LOAD procedure, 7.2.2.2
    END_INSTANTIATION procedure, 7.2.2.2
    END_LOAD procedure, 7.2.2.2
    RESUME_SUBSET_OF_MASTERS procedure, 7.2.2.2
  DBMS_OFFLINE_SNAPSHOT package
    END_LOAD procedure, 8.5, 8.5, 8.5, 8.5, 8.5, 8.5, 8.5
  DBMS_RECTIFIER_DIFF package, 9.4, 16
    DIFFERENCES procedure, 9.4.1
    RECTIFY procedure, 9.4.2
  DBMS_REFRESH package, 17
    ADD procedure, 5.2.2, 8.5
    MAKE procedure, 5.2.1, 5.2.2, 8.5
    REFRESH procedure, 8.1
  DBMS_REPCAT package, 7.4, 18
    ADD_MASTER_DATABASE procedure, 3.2, 7.2.2, 7.2.2.1
    ADD_NEW_MASTERS procedure, 7.2.1.1, 7.2.1.2
    ADD_SITE_PRIORITY_SITE procedure, 6.2.6
    ADD_UPDATE_RESOLUTION procedure, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6
    ALTER_MASTER_REPOBJECT procedure, 6.2.3, 6.2.6, 6.4, 9.1.1
    CANCEL_STATISTICS procedure, 6.6.3
    CREATE_MASTER_REPGROUP procedure, 3.2
    CREATE_MASTER_REPOBJECT procedure, 6.2.3, 6.2.6
    CREATE_MVIEW_REPGROUP procedure, 5.2.1, 8.5, 8.6, 8.6
    CREATE_MVIEW_REPOBJECT procedure, 5.2.1, 5.2.1, 5.2.1, 5.2.1, 5.2.1, 5.2.1, 5.2.2, 5.2.2, 5.2.2, 5.2.2, 5.2.2, 5.2.2, 5.2.2, 8.6, 8.6
    DEFINE_SITE_PRIORITY procedure, 6.2.6
    DO_DEFERRED_REPCAT_ADMIN procedure, 6.4, 7.2.2.2
    DROP_MVIEW_REPGROUP procedure, 8.3.1.1, 8.3.1.2, 8.3.2.1
    DROP_MVIEW_REPOBJECT procedure, 8.3.2.2
    GENERATE_REPLICATION_SUPPORT procedure, 3.2, 3.2, 3.2, 3.2, 3.2, 3.2, 3.2, 9.1.1
    MAKE_COLUMN_GROUP procedure, 6.2.1, 6.2.2, 6.2.3, 6.2.3, 6.2.4, 6.2.5, 6.2.6
    PREPARE_INSTANTIATED_MASTER procedure, 7.2.1.1, 7.2.1.2
    PURGE_STATISTICS procedure, 6.6.4
    REGISTER_STATISTICS procedure, 6.6.1
    RELOCATE_MASTERDEF procedure, 7.1.1
    REMOVE_MASTER_DATABASE procedure, 7.3
    RESUME_MASTER_ACTIVITY procedure, 3.2
    RESUME_PROPAGATION_TO_MDEF procedure, 7.2.1.1, 7.2.1.2
    SPECIFY_NEW_MASTERS procedure, 7.2.1.1, 7.2.1.2
    SWITCH_MVIEW_MASTER procedure, 8.2
    UNREGISTER_MVIEW_REPGROUP procedure, 8.3.3.1
  DBMS_REPCAT_ADMIN package, 20
    GRANT_ADMIN_ANY_SCHEMA procedure, 2.2.1, 2.3.1, 2.3.2
    REGISTER_USER_REPGROUP procedure, 2.2.1, 2.2.1, 2.2.2, 2.2.3, 2.3.1, 2.3.1
  DBMS_REPCAT_INSTANTIATE package, 19
    DROP_SITE_INSTANTIATION procedure, 8.3.1.1, 8.3.1.2
  DBMS_REPCAT_RGT package, 21
    CREATE_REFRESH_TEMPLATE procedure, 4.3
    CREATE_TEMPLATE_OBJECT procedure, 4.3
    CREATE_USER_AUTHORIZATION procedure, 4.3
    INSTANTIATE_OFFLINE procedure, 4.4.1.1
    INSTANTIATE_ONLINE procedure, 4.4.1.2
  DBMS_REPUTIL package, 22
    REPLICATION_OFF procedure, 7.5.4, 9.2.1
    REPLICATION_ON procedure, 7.5.4, 9.2.2
  DDL. See data definition language
  DEFCALL view, 25
  DEFCALLDEST view, 25
  DEFDEFAULTDEST view, 25
    adding destinations to, 14
    removing destinations from, 14, 14
  DEFERRCOUNT view, 25
  deferred transaction queues
    deferred calls
      determining value of, 9.5.3
    managing, 9.5
    purging propagated transactions, 9.5.2
    pushing, 9.5.1
  deferred transactions
    data dictionary views, 25
    DEFDEFAULTDEST view
      adding destination to, 14
      removing destinations from, 14
    deferred remote procedure calls (RPCs)
      argument types, 13
      argument values, 13
      arguments to, 12
      building, 12
      executing immediately, 14
    DEFSCHEDULE view
      clearing statistics, 14
      removing destinations from, 14
    deleting from queue, 14
    monitoring, 10.4
      purge job, 10.4.2.1, 10.4.2.2
      push jobs, 10.4.1.2, 10.4.1.3
    reexecuting, 14
    scheduling execution, 14
    starting, 12
  DEFERROR view, 9.6, 25
    deleting transactions from, 14
  DEFINE_COLUMN_GROUP procedure, 18
  DEFINE_PRIORITY_GROUP procedure, 18
  DEFINE_SITE_PRIORITY procedure, 6.2.6, 18
  DEFLOB view, 25
  DEFPROPAGATOR view, 25, 25
  DEFSCHEDULE view, 25
    clearing statistics, 10.6.6, 14
  DEFTRAN view, 25
  DEFTRANDEST view, 25
  DELETE_DEF_DESTINATION procedure, 14
  DELETE_DEFAULT_DEST procedure, 14
  DELETE_ERROR procedure, 14
  DELETE_RUNTIME_PARMS procedure, 21
  DELETE_TRAN procedure, 14
  deployment templates
    alter object, 21
    alter parameters, 21
    alter template, 21
    alter user authorization, 21
    alter user parameter values, 21
    authorize users, 4.3
    compare templates, 21
    concepts, 4.1
    copy template, 21
    create object from existing, 21
    create template, 21
    creating, 4.3, 4.3
    data dictionary views for, 23
    distributing files, 4.4.3
    drop site instantiation, 19
    dropping, 21
    dropping all, 21
    dropping materialized view group, 8.3.1
    flowchart for creating, 4.3
    instantiating, 4.4.4
    instantiation script, 4.4.2
    lock template, 21, 21
    monitoring, 10.1.3.4
    objects
      creating, 21
      dropping, 21
      dropping all, 21
    offline instantiation, 4.4, 19, 21
    online instantiation, 19, 21
    packaging, 4.4, 4.4.1
      for offline instantiation, 4.4.1.1
      for online instantiation, 4.4.1.2
    parameters
      creating, 4.3, 21
      dropping, 21
      dropping all, 21
      user values, 4.3
    runtime parameters
      creating, 21
      deleting, 21
      get ID, 21
      inserting, 21
    sites
      dropping, 21
      dropping all, 21
    user authorizations
      creating, 21
      dropping, 21
      dropping all, 21
    user parameter values
      creating, 21
      dropping, 21
      dropping all, 21
    user-defined types, 4.1
  DESTROY procedure, 17
  differences
    between tables, 16
      rectifying, 16
  DIFFERENCES procedure, 9.4.1, 16
  DISABLED function, 14
  disabling
    propagation, 14
  DO_DEFERRED_REPCAT_ADMIN procedure, 6.4, 7.2.2.2, 18
  DROP MATERIALIZED VIEW LOG statement, 8.4.4
  DROP_ALL_OBJECTS procedure, 21
  DROP_ALL_TEMPLATE_PARMS procedure, 21
  DROP_ALL_TEMPLATE_SITES procedure, 21
  DROP_ALL_TEMPLATES procedure, 21
  DROP_ALL_USER_AUTHORIZATIONS procedure, 21
  DROP_ALL_USER_PARM_VALUES procedure, 21
  DROP_COLUMN_GROUP procedure, 18
  DROP_DELETE_RESOLUTION procedure, 18
  DROP_GROUPED_COLUMN procedure, 18
  DROP_MASTER_REPGROUP procedure, 18
  DROP_MASTER_REPOBJECT procedure, 18
  DROP_MVIEW_REPGROUP procedure, 8.3.1.1, 8.3.1.2, 18
  DROP_MVIEW_REPOBJECT procedure, 8.3.2.2, 18
  DROP_PRIORITY procedure, 18
  DROP_PRIORITY_CHAR procedure, 18
  DROP_PRIORITY_datatype procedure, 18
  DROP_PRIORITY_DATE procedure, 18
  DROP_PRIORITY_GROUP procedure, 18
  DROP_PRIORITY_NUMBER procedure, 18
  DROP_PRIORITY_VARCHAR2 procedure, 18
  DROP_REFRESH_TEMPLATE procedure, 21
  DROP_SITE_INSTANTIATION procedure, 8.3.1.1, 8.3.1.2, 19, 21
  DROP_SITE_PRIORITY procedure, 18
  DROP_SITE_PRIORITY_SITE procedure, 18
  DROP_TEMPLATE_OBJECT procedure, 21
  DROP_TEMPLATE_PARM procedure, 21
  DROP_UNIQUE_RESOLUTION procedure, 18
  DROP_UPDATE_RESOLUTION procedure, 18
  DROP_USER_AUTHORIZATION procedure, 21
  DROP_USER_PARM_VALUE procedure, 21
  dynamic ownership
    conflict avoidance and, 6.5
    locating owner of a row, 6.5.3
    obtaining ownership, 6.5.4
    workflow partitioning, 6.5.1
  dynamic performance views
    replication, 24

## E

  END_INSTANTIATION procedure, 7.2.2.2, 15
  END_LOAD procedure, 7.2.2.2, 8.5, 8.5, 15
  END_TABLE_REORGANIZATION procedure, 8.4.3.1
  errors
    error queues
      DEFERROR view, 9.6
      managing, 9.6
    error transactions
      monitoring, 10.5
      reexecuting as alternate user, 9.6.2
      reexecuting as receiver, 9.6.1
      reexecuting multiple, 9.6
  EXCLUDE_PUSH function, 14
  EXECUTE_DDL procedure, 18
  EXECUTE_ERROR procedure, 7.2.2.2, 9.6.1, 14
  EXECUTE_ERROR_AS_USER procedure, 9.6.2, 14
  extended availability, 6.2, 7.2.1, 9.1.1, 18, 18, 18, 18, 18, 18

## F

  foreign key constraints
    adding master sites, 7.2
  FROM_REMOTE function, 22

## G

  GENERATE_MVIEW_SUPPORT procedure, 18
  GENERATE_REPLICATION_SUPPORT procedure, 3.2, 3.2, 9.1.1, 18
  generating
    replication support, 3.2
      procedural replication, 7.5.4
  GET_ANYDATA_ARG function, 9.5.3, 13
  GET_ARG_FORM function, 13
  GET_ARG_TYPE function, 13
  GET_BLOB_ARG function, 13
  GET_CALL_ARGS procedure, 13
  GET_CHAR_ARG function, 13
  GET_CLOB_ARG function, 13
  GET_datatype_ARG function, 13
  GET_DATE_ARG function, 13
  GET_IDS_ARG function, 13
  GET_IYM_ARG function, 13
  GET_NCHAR_ARG function, 13
  GET_NCLOB_ARG function, 13
  GET_NUMBER_ARG function, 13
  GET_NVARCHAR2_ARG function, 13
  GET_OBJECT_NULL_VECTOR_ARG function, 13
  GET_RAW_ARG function, 13
  GET_ROWID_ARG function, 13
  GET_RUNTIME_PARM_ID function, 21
  GET_TIMESTAMP_ARG function, 13
  GET_TSLTZ_ARG function, 13
  GET_TSTZ_ARG function, 13
  GET_VARCHAR2_ARG function, 13
  GLOBAL_NAME function, 22
  GRANT_ADMIN_ANY_SCHEMA procedure, 2.2.1, 2.3.1, 2.3.2, 20
  GRANT_ADMIN_SCHEMA procedure, 20

## I

  IDS_ARG procedure, 12
  Import
    replication groups
      offline instantiation and, 15, 15
    status check, 18
  INSERT_RUNTIME_PARMS procedure, 21
  INSTANTIATE_OFFLINE function, 19, 21
  INSTANTIATE_OFFLINE procedure, 4.4.1.1
  INSTANTIATE_ONLINE function, 19, 21
  INSTANTIATE_ONLINE procedure, 4.4.1.2
  instantiation, 4.4.4
    DROP_SITE_INSTANTIATION procedure, 19, 21
    offline, 4.4
      INSTANTIATE_OFFLINE function, 19, 21
    online
      INSTANTIATE_ONLINE function, 19, 21
    refreshing after, 4.4.5
    script, 4.4.2
  IYM_ARG procedure, 12

## J

  jobs
    queues for
      removing jobs from, 14, 14

## L

  LOCK_TEMPLATE_EXCLUSIVE procedure, 21
  LOCK_TEMPLATE_SHARED procedure, 21
  LONG columns
    replication, 9.3

## M

  MAKE procedure, 5.2.1, 5.2.2, 8.5, 17
  MAKE_COLUMN_GROUP procedure, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.6, 18
  MAKE_INTERNAL_PKG procedure, 22
  master definition site
    relocating, 18
  master groups
    adding master sites to
      with quiesce, 7.2.2
      without quiesce, 7.2.1
    adding objects to, 3.2
    creating, 3.1, 3.2, 18
    dropping, 18
    flowchart for creating, 3.1.1
    monitoring, 10.1.2
    quiescing, 18
    removing master sites from, 7.3
    resuming replication activity, 18
  master materialized views
    monitoring, 10.1.3
    reorganizing, 8.4.3
  master sites
    adding, 3.2, 7.2
      circular dependencies, 3.2, 7.2
      flowchart for, 7.2.1.2
      flowchart for determining method, 7.2.1
      foreign key constraints, 7.2
      restrictions, 7.2.1
      restrictions for change-based recovery, 7.2.1
      restrictions for full database export/import, 7.2.1
      self-referential constraints, 3.2, 7.2
      using change-based recovery, 7.2.1.1
      using full database export/import, 7.2.1.1
      using object-level export/import, 7.2.1.2
      using offline instantiation, 7.2.2.2
      with quiesce, 7.2.2
      without quiesce, 7.2.1
    changing master definition site, 7.1
    cleaning up, 8.3.3
    creating, 18
    creating users for, 2.2.1, 2.2.1, 2.2.2, 2.2.2, 2.2.3, 2.2.3, 2.3.1
    database links, 2.2.4
    determining differences, 9.4
    dropping, 18
    flowchart for setting up, 2.1
    monitoring, 10.1.1, 10.1.3
    propagating changes between, 14
    removing, 7.3
    scheduled links for, 2.2.4
    scheduled purges for, 2.2.1
    setup, 2.2
  master tables
    adding columns to, 18
    redefining online, 8.4.3
    reorganizing, 8.4.3
      methods, 8.4.3.3
    truncating, 8.4.3.2
  materialized view groups
    adding objects to, 5.2.1, 5.2.2, 8.6
    changing masters, 8.2
    creating, 5.2, 5.2.1, 5.2.2, 18
    dropping, 8.3.1, 8.3.2.1
    group owner, 8.6
    monitoring, 10.2.2
    refreshing, 18
  materialized view logs
    adding columns, 8.4.1.2
    altering, 8.4.1
      privileges required, 8.4.1
    dropping, 8.4.4
    managing, 8.4
      space, 8.4.2
    monitoring, 10.1.3.2
    purging
      materialized views from, 8.3.3.1, 8.3.3.2
      privileges required, 8.4.2.1
    purging rows from
      manually, 8.4.2.1
    reducing space allocated to, 8.4.2.2
    reorganizing masters with, 8.4.3
    truncating, 8.4.2.2
    truncating master table with, 8.4.3.2
  materialized view sites
    adding
      using offline instantiation, 8.5
    administrators
      creating, 2.3.1
    changing masters, 18
    database links
      creating, 2.3.2, 4.4.4, 5.2.1, 5.2.2, 8.6
    dropping, 8.3, 18
    dropping objects from, 8.3.2
    flowchart for setting up, 2.3
    group owner
      using, 8.6
    monitoring, 10.2.1
    multitier
      setting up, 2.3
    propagating changes to master, 14
    refresher
      creating, 2.3.1, 2.3.2
    schedule purge, 2.3.1, 2.3.1, 2.3.2, 2.3.2
    users
      creating, 2.3.1
  materialized views
    data dictionary views, 26
    deployment templates
      user-defined types, 4.1
    dropping, 8.3.2.2
    generating support for, 18
    monitoring, 10.2, 10.2.3
    multitier
      setting up, 5.2
      user-defined conflict resolution, B.1.5
    purging from materialized view logs, 8.3.3.1, 8.3.3.2
    refresh groups
      creating, 5.2.1, 5.2.2
    refreshing, 4.4.5, 8.1, 8.5
    security, A.2
      trusted compared with untrusted, A.2.1
    unregistering from master, 8.3.3.2
  multimaster replication
    monitoring, 10.1
    security
      trusted compared with untrusted, A.1.1
  multitier materialized views
    setting up, 2.3

## N

  NCHAR_ARG procedure, 12
  NCLOB_ARG procedure, 12
  notification log table
    conflicts
      creating, B.2.1
      sample, B.2.1.1
  notification methods
    user-defined, B.2
  notification package
    conflicts
      creating, B.2.2
  NUMBER_ARG procedure, 12
  NVARCHAR2_ARG procedure, 12

## O

  objects
    adding to materialized view sites, 18
    altering, 18
    altering replication, 9.1
    creating
      for master group, 18, 18
      for materialized view sites, 18
    dropping
      from materialized view site, 8.3.2, 18
    generating replication support for, 18, 18
  offline instantiation
    adding a master site, 7.2.2.2
    adding a materialized view site, 8.5
    INSTANTIATE_OFFLINE function, 19, 21
    replication groups, 15, 15, 15, 15, 15
  online instantiation
    INSTANTIATE_ONLINE function, 19, 21
  online redefinition of tables, 8.4.3
  Oracle Replication Management tool
    monitoring replication, 10
  Oracle Streams
    migrating to, 18

## P

  packaging
    deployment templates, 4.4
  parallel propagation
    monitoring, 10.6.5, 10.6.7
  parameters
    deployment templates, 4.3
    user values, 4.3
  performance
    replication
      monitoring, 10.6
  planning
    for replication, 1.2
  PREPARE_INSTANTIATED_MASTER procedure, 7.2.1.1, 7.2.1.2
  PREPARE_INSTANTIATED_MASTERS procedure, 18
  PRESERVE MATERIALIZED VIEW LOG option
    TRUNCATE TABLE statement, 8.4.3.2
  priority groups
    adding members to, 18
    altering members
      priorities, 18
      values, 18
    creating, 18
    dropping, 18
    removing members from, 18, 18
    site priority groups
      adding members to, 18
  procedural replication
    conflicts and, 7.5.3
    generating replication support for, 7.5.4
    restrictions, 7.5.1
    serialization of transactions, 7.5.3
    user-defined types, 7.5.2
    using, 7.5
  propagation
    altering method, 18, 18
    disabling, 14
    of changes, 18
    parallel
      monitoring, 10.6.5, 10.6.7
    status of, 14
  propagator
    registering, 2.2.1, 2.2.1, 14
  proxy materialized view administrator
    creating, 2.2.1, 2.2.1, 2.2.2, 2.2.2, 2.2.3, 2.2.3, 2.3.1
  PURGE function, 9.5.2, 14
  PURGE_LOG procedure, 8.4.2.1
  PURGE_MASTER_LOG procedure, 18
  PURGE_MVIEW_FROM_LOG procedure, 8.3.3.1, 8.3.3.2, 8.3.3.2, 8.4.2.1
  PURGE_STATISTICS procedure, 6.6.4, 18
  purges
    DBA_REPCATLOG table, 18
    deferred transaction queue, 9.5.2
      master sites, 2.2.1
      materialized view sites, 2.3.1, 2.3.2
      monitoring, 10.4.2
  PUSH function, 9.5.1, 14
  pushes
    deferred transaction queue, 9.5.1

## Q

  quiescing
    adding master sites with, 7.2.2
    adding master sites without, 7.2.1
    altering replicated objects without, 9.1.1
    configuring conflict resolution methods without, 6.2
    master groups, 18

## R

  RAW_ARG procedure, 12
  receiver
    registering, 2.2.1
  RECTIFY procedure, 9.4.2, 16
  rectifying
    tables, 9.4.2, 16
  redefining tables
    online
      replication, 8.4.3
  refresh
    materialized view sites, 18
    materialized views, 8.1, 8.5
    monitoring, 10.2.5, 10.2.6
  refresh groups
    adding members to, 17
    adding objects to, 5.2.1, 5.2.2, 8.5
    creating, 5.2.1, 5.2.2, 17
    data dictionary views, 26
    deleting, 17
    monitoring, 10.2.4
    refresh, 8.1
    refresh interval
      changing, 17
    refreshing
      manually, 17
    removing members from, 17
  REFRESH procedure, 8.1, 8.1, 8.5, 17
  REFRESH_ALL_MVIEWS procedure, 8.1
  REFRESH_DEPENDENT procedure, 8.1
  REFRESH_MVIEW_REPGROUP procedure, 18
  refresher
    creating, 2.3.1, 2.3.2
  REGISTER_MVIEW_REPGROUP procedure, 18
  REGISTER_PROPAGATOR procedure, 2.2.1, 2.3.1, 2.3.2, 14
  REGISTER_STATISTICS procedure, 6.6.1, 18
  REGISTER_USER_REPGROUP procedure, 2.2.1, 2.2.1, 2.2.2, 2.2.3, 2.3.1, 2.3.1, 20
  RELOCATE_MASTERDEF procedure, 7.1.1, 18
  REMOVE_MASTER_DATABASE procedure, 7.3
  REMOVE_MASTER_DATABASES procedure, 18
  RENAME_SHADOW_COLUMN_GROUP procedure, 18
  REPCAT_IMPORT_CHECK procedure, 18
  replication
    catalog views, 10, 23
    column groups, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6
    conflict resolution, 6
      uniqueness, 6.3
    creating an environment, 1.1
    data dictionary views, 10, 23
    database links
      creating, 2.2.4
    datetime datatypes
      abbreviations, 11.4
    deferred transaction queues
      managing, 9.5
    deferred transactions
      data dictionary views, 25
    deployment templates
      user-defined types, 4.1
    determining differences between tables, 9.4
    disabling, 7.5.4, 9.2, 9.2.1, 22
    dynamic performance views, 24
    enabling, 7.5.4, 9.2, 9.2.2, 22
    error queues
      managing, 9.6
    flowchart for creating environment, 1.1
    generating support for, 3.2
    interval datatypes
      abbreviations, 11.4
    LONG column
      converting to LOB, 9.3
    managing an environment, 6
    master groups
      creating, 3.1
    master sites
      adding, 3.2
    materialized view groups
      creating, 5.2, 5.2.1, 5.2.2
    materialized view logs
      managing, 8.4
    monitoring, 10
      deferred transactions, 10.4
      error transactions, 10.5
      master environments, 10.1
      materialized view environments, 10.2
      performance, 10.6
    objects
      adding to master group, 3.2
      altering, 9.1
      dropping from master sites, 18
    parallel propagation
      monitoring, 10.6.5, 10.6.7
    planning for, 1.2
    procedural replication, 7.5
      restrictions, 7.5.1
      user-defined types, 7.5.2
    propagator
      registering, 2.2.1, 2.2.1
    receiver
      registering, 2.2.1
    replicated objects, 9
    replication queues, 9
    resuming, 3.2
    scheduled links
      creating, 2.2.4
    security, A
    setting up sites, 2.1
    sites
      setup, 2.1
    statistics
      clearing, 10.6.6
    triggers, 9.2.3
  replication catalog views, 23
    comments
      updating, 7.4, 7.4
    monitoring replication, 10
  replication management API, 11
    conflict resolution, 6
    deployment templates
      creating, 4.3
      instantiating, 4.4.4
      packaging, 4.4
    examples, 11.1
    managing a replication environment, 6
    managing replicated objects, 9
    managing replication queues, 9
    master groups
      creating, 3.1
    materialized view groups
      creating, 5.2
    overview, 1
    packages, 10
    setting up replication sites, 2.1
  replication objects
    altering, 9.1.1
    tables
      altering, 9.2
  REPLICATION_IS_ON function, 22
  REPLICATION_OFF procedure, 22
  REPLICATION_ON procedure, 7.5.4, 7.5.4, 22
  RESUME_MASTER_ACTIVITY procedure, 3.2, 18
  RESUME_PROPAGATION_TO_MDEF procedure, 7.2.1.1, 7.2.1.2, 18
  RESUME_SUBSET_OF_MASTERS procedure, 7.2.2.2, 15
  resuming replication activity, 18
  REVOKE_ADMIN_ANY_SCHEMA procedure, 20
  REVOKE_ADMIN_SCHEMA procedure, 20
  ROWID_ARG procedure, 12

## S

  SCHEDULE_PURGE procedure, 2.2.1, 2.3.1, 2.3.2, 14
  SCHEDULE_PUSH procedure, 2.2.4, 2.3.1, 2.3.2, 14
  scheduled links
    creating, 2.2.4
  security
    for materialized view replication, A.2
      trusted compared with untrusted, A.2.1
    for multimaster replication, A.1
      trusted compared with untrusted, A.1.1
    replication, A
    trusted compared with untrusted, A.1.1, A.2.1
  SEND_OLD_VALUES procedure, 18
  serialization
    of transactions, 7.5.3
  SET_COLUMNS procedure, 18, 18
  SET_DISABLED procedure, 14
  site priority
    altering, 18
  site priority groups
    adding members to, 18
    creating
      syntax, 18
    dropping, 18
    removing members from, 18
  snapshots. See materialized views
  SPECIFY_NEW_MASTERS procedure, 7.2.1.1, 18
  statistics
    for conflict resolution
      auditing, 6.6
      cancelling, 6.6.3
      clearing, 6.6.4, 18
      collecting, 6.6.1, 18
      viewing, 6.6.2
    for propagation
      clearing, 10.6.6, 14
  status
    propagation, 14
  storage parameters
    materialized view log
      altering, 8.4.1.1
  STREAMS_MIGRATION procedure, 18
  SUBTRACT procedure, 17
  SUSPEND_MASTER_ACTIVITY procedure, 18
  SWITCH_MVIEW_MASTER procedure, 8.2, 18
  SYNC_UP_REP procedure, 22

## T

  tables
    altering
      without replicating changes, 9.2
    altering replicated, 9.1.1
    comparing, 16
    differences between, 9.4
    rectifying, 9.4.2, 16
    redefining online
      replication, 8.4.3
    updating comments, 7.4, 7.4
  templates. See deployment templates
  TIMESTAMP_ARG procedure, 12
  token passing, 6.5.2
    sample implementation, 6.5
  TRANSACTION procedure, 12
  transactions
    serialization of, 7.5.3
  triggers
    for site priority conflict resolution, 6.2.6
    for timestamp conflict resolution, 6.2.3
    replicating, 9.2.3
  TRUNCATE statement, 8.4.2.2
  TRUNCATE TABLE statement
    PRESERVE MATERIALIZED VIEW LOG option, 8.4.3.2
  trusted security, A.1.1, A.2.1
  TSLTZ_ARG procedure, 12

## U

  UNDO_ADD_NEW_MASTERS_REQUEST procedure, 18
  UNREGISTER_MVIEW procedure, 8.3.3.2
  UNREGISTER_MVIEW_REPGROUP procedure, 18
  UNREGISTER_PROPAGATOR procedure, 14
  UNREGISTER_USER_REPGROUP procedure, 20
  UNSCHEDULE_PURGE procedure, 14
  UNSCHEDULE_PUSH procedure, 14
  USER_REPCAT_REFRESH_TEMPLATES view, 23
  USER_REPCAT_TEMP_OUTPUT view, 4.4.1
  USER_REPCAT_TEMPLATE_OBJECTS view, 23
  USER_REPCAT_TEMPLATE_PARMS view, 23
  USER_REPCAT_TEMPLATE_SITES view, 23
  USER_REPCAT_USER_AUTHORIZATIONS view, 23
  USER_REPCAT_USER_PARM_VALUES view, 23
  USER_REPCATLOG view, 23
  USER_REPCOLUMN view, 23
  USER_REPCOLUMN_GROUP view, 23
  USER_REPCONFLICT view, 23, 23
  USER_REPDDL view, 23, 23
  USER_REPGENOBJECTS view, 23, 23
  USER_REPGROUP view, 23
  USER_REPGROUP_PRIVILEGES view, 23
  USER_REPGROUPED_COLUMN view, 23
  USER_REPKEY_COLUMNS view, 23
  USER_REPOBJECT view, 23
  USER_REPPARAMETER_COLUMN view, 23
  USER_REPPRIORITY view, 23
  USER_REPPRIORITY_GROUP view, 23
  USER_REPPROP view, 23
  USER_REPRESOL_STATS_CONTROL view, 23
  USER_REPRESOLUTION view, 23
  USER_REPRESOLUTION_METHOD view, 23
  USER_REPRESOLUTION_STATISTICS view, 23
  USER_REPSITES view, 23
  users
    authorize for deployment template, 4.3
    master materialized view sites, 2.3.1
    master sites, 2.2.1, 2.2.1, 2.2.2, 2.2.2, 2.2.3, 2.2.3
    materialized view sites, 2.3.1

## V

  V$MVREFRESH view, 24
  V$REPLPROP view, 10.6.7, 24
  V$REPLQUEUE view, 24
  VALIDATE procedure, 18
  VARCHAR2_ARG procedure, 12

## W

  WAIT_MASTER_LOG procedure, 18
  workflow, 6.5.1